Pandas Profiling Report

Dataset statistics

Number of variables	13
Number of observations	2966
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	301.4 KiB
Average record size in memory	104.0 B

Variable types

Numeric	13

Alerts

`gross_revenue` is highly correlated with `qtde_invoices` and 4 other fields	High correlation
`recency_days` is highly correlated with `qtde_invoices`	High correlation
`qtde_invoices` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`qtde_items` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`qtde_products` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`avg_recency_days` is highly correlated with `frequency`	High correlation
`frequency` is highly correlated with `avg_recency_days`	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`avg_unique_basket_size` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`gross_revenue` is highly correlated with `qtde_invoices` and 1 other fields	High correlation
`qtde_invoices` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`qtde_items` is highly correlated with `gross_revenue` and 1 other fields	High correlation
`qtde_products` is highly correlated with `qtde_invoices`	High correlation
`avg_ticket` is highly correlated with `qtde_returns` and 2 other fields	High correlation
`qtde_returns` is highly correlated with `avg_ticket` and 2 other fields	High correlation
`avg_basket_size` is highly correlated with `avg_ticket` and 2 other fields	High correlation
`avg_unique_basket_size` is highly correlated with `avg_ticket` and 2 other fields	High correlation
`gross_revenue` is highly correlated with `qtde_invoices` and 2 other fields	High correlation
`qtde_invoices` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`qtde_items` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`qtde_products` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`avg_recency_days` is highly correlated with `frequency`	High correlation
`frequency` is highly correlated with `avg_recency_days`	High correlation
`avg_basket_size` is highly correlated with `qtde_items` and 1 other fields	High correlation
`avg_unique_basket_size` is highly correlated with `qtde_items` and 1 other fields	High correlation
`gross_revenue` is highly correlated with `qtde_invoices` and 6 other fields	High correlation
`qtde_invoices` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`qtde_items` is highly correlated with `gross_revenue` and 6 other fields	High correlation
`qtde_products` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`avg_ticket` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`qtde_returns` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`avg_unique_basket_size` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`avg_ticket` is highly skewed (γ1 = 53.41722918)	Skewed
`frequency` is highly skewed (γ1 = 24.93321178)	Skewed
`qtde_returns` is highly skewed (γ1 = 51.77236982)	Skewed
`avg_basket_size` is highly skewed (γ1 = 44.65585181)	Skewed
`avg_unique_basket_size` is highly skewed (γ1 = 44.65585181)	Skewed
`df_index` has unique values	Unique
`customer_id` has unique values	Unique
`recency_days` has 34 (1.1%) zeros	Zeros
`qtde_returns` has 1480 (49.9%) zeros	Zeros

Reproduction

Analysis started	2021-11-19 18:22:09.933326
Analysis finished	2021-11-19 18:22:31.502148
Duration	21.57 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	2966
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2309.167229

Minimum	0
Maximum	5690
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	185.25
Q1	926.25
median	2113.5
Q3	3523.75
95-th percentile	5011
Maximum	5690
Range	5690
Interquartile range (IQR)	2597.5

Descriptive statistics

Standard deviation	1547.505435
Coefficient of variation (CV)	0.6701573693
Kurtosis	-1.011941625
Mean	2309.167229
Median Absolute Deviation (MAD)	1265.5
Skewness	0.3397296495
Sum	6848990
Variance	2394773.072
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
3002	1	< 0.1%
2987	1	< 0.1%
2990	1	< 0.1%
2991	1	< 0.1%
2992	1	< 0.1%
2993	1	< 0.1%
2996	1	< 0.1%
2998	1	< 0.1%
2999	1	< 0.1%
Other values (2956)	2956	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
5690	1	< 0.1%
5671	1	< 0.1%
5661	1	< 0.1%
5655	1	< 0.1%
5634	1	< 0.1%
5630	1	< 0.1%
5624	1	< 0.1%
5613	1	< 0.1%
5612	1	< 0.1%
5602	1	< 0.1%

customer_id
Real number (ℝ_≥0)

UNIQUE

Distinct	2966
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15270.64633

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	12347
5-th percentile	12619.25
Q1	13799.75
median	15220.5
Q3	16769.5
95-th percentile	17964.75
Maximum	18287
Range	5940
Interquartile range (IQR)	2969.75

Descriptive statistics

Standard deviation	1719.368253
Coefficient of variation (CV)	0.1125930243
Kurtosis	-1.206285243
Mean	15270.64633
Median Absolute Deviation (MAD)	1487
Skewness	0.03191154775
Sum	45292737
Variance	2956227.19
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
17588	1	< 0.1%
14905	1	< 0.1%
16103	1	< 0.1%
14626	1	< 0.1%
14868	1	< 0.1%
18246	1	< 0.1%
17115	1	< 0.1%
16611	1	< 0.1%
15912	1	< 0.1%
Other values (2956)	2956	99.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18269	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2951
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2749.410125

Minimum	6.2
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	6.2
5-th percentile	230.9525
Q1	571.02
median	1085.51
Q3	2310.295
95-th percentile	7226.025
Maximum	279138.02
Range	279131.82
Interquartile range (IQR)	1739.275

Descriptive statistics

Standard deviation	10565.12098
Coefficient of variation (CV)	3.842686431
Kurtosis	355.1680075
Mean	2749.410125
Median Absolute Deviation (MAD)	672.255
Skewness	16.79499336
Sum	8154750.43
Variance	111621781.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2053.02	2	0.1%
331	2	0.1%
734.94	2	0.1%
1025.44	2	0.1%
598.2	2	0.1%
533.33	2	0.1%
731.9	2	0.1%
2092.32	2	0.1%
379.65	2	0.1%
745.06	2	0.1%
Other values (2941)	2946	99.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6.2	1	< 0.1%
13.3	1	< 0.1%
36.56	1	< 0.1%
45	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%
70.02	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
136263.72	1	< 0.1%
124564.53	1	< 0.1%
116725.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%

recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	272
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.19386379

Minimum	0
Maximum	373
Zeros	34
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	11
median	31
Q3	81
95-th percentile	242
Maximum	373
Range	373
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	77.57405542
Coefficient of variation (CV)	1.208434122
Kurtosis	2.761755779
Mean	64.19386379
Median Absolute Deviation (MAD)	26
Skewness	1.795023771
Sum	190399
Variance	6017.734074
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.3%
4	87	2.9%
3	85	2.9%
2	84	2.8%
8	76	2.6%
10	67	2.3%
7	66	2.2%
9	66	2.2%
17	64	2.2%
22	55	1.9%
Other values (262)	2217	74.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	34	1.1%
1	99	3.3%
2	84	2.8%
3	85	2.9%
4	87	2.9%
5	43	1.4%
7	66	2.2%
8	76	2.6%
9	66	2.2%
10	67	2.3%

Value	Count	Frequency (%)
373	2	0.1%
372	3	0.1%
371	1	< 0.1%
368	1	< 0.1%
366	4	0.1%
365	2	0.1%
364	1	< 0.1%
360	1	< 0.1%
359	1	< 0.1%
358	4	0.1%

qtde_invoices
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	57
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.722859069

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	205
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	8.845920929
Coefficient of variation (CV)	1.545717066
Kurtosis	190.2175037
Mean	5.722859069
Median Absolute Deviation (MAD)	2
Skewness	10.74683007
Sum	16974
Variance	78.25031708
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	786	26.5%
3	496	16.7%
4	394	13.3%
5	236	8.0%
1	189	6.4%
6	173	5.8%
7	139	4.7%
8	98	3.3%
9	69	2.3%
10	54	1.8%
Other values (47)	332	11.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	189	6.4%
2	786	26.5%
3	496	16.7%
4	394	13.3%
5	236	8.0%
6	173	5.8%
7	139	4.7%
8	98	3.3%
9	69	2.3%
10	54	1.8%

Value	Count	Frequency (%)
206	1	< 0.1%
198	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	1	< 0.1%
90	1	< 0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%

qtde_items
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1671
Distinct (%)	56.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1607.823668

Minimum	2
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	2
5-th percentile	103
Q1	297
median	641
Q3	1399
95-th percentile	4408
Maximum	196844
Range	196842
Interquartile range (IQR)	1102

Descriptive statistics

Standard deviation	5885.360067
Coefficient of variation (CV)	3.660451194
Kurtosis	466.8037951
Mean	1607.823668
Median Absolute Deviation (MAD)	422
Skewness	17.87136764
Sum	4768805
Variance	34637463.11
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
88	9	0.3%
150	9	0.3%
84	8	0.3%
246	8	0.3%
260	8	0.3%
134	8	0.3%
272	8	0.3%
288	8	0.3%
1200	7	0.2%
Other values (1661)	2882	97.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	2	0.1%
12	2	0.1%
16	1	< 0.1%
17	1	< 0.1%
18	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
23	1	< 0.1%
25	1	< 0.1%
26	1	< 0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80997	1	< 0.1%
79879	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
62812	1	< 0.1%
58243	1	< 0.1%
57772	1	< 0.1%

qtde_products
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	468
Distinct (%)	15.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	122.7508429

Minimum	1
Maximum	7837
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	9
Q1	29
median	67
Q3	135
95-th percentile	382
Maximum	7837
Range	7836
Interquartile range (IQR)	106

Descriptive statistics

Standard deviation	269.3561638
Coefficient of variation (CV)	2.194332499
Kurtosis	354.1690203
Mean	122.7508429
Median Absolute Deviation (MAD)	44
Skewness	15.67332496
Sum	364079
Variance	72552.74296
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	46	1.6%
20	38	1.3%
35	35	1.2%
15	33	1.1%
29	32	1.1%
11	32	1.1%
19	32	1.1%
25	30	1.0%
26	30	1.0%
27	30	1.0%
Other values (458)	2628	88.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	5	0.2%
2	14	0.5%
3	16	0.5%
4	17	0.6%
5	26	0.9%
6	28	0.9%
7	18	0.6%
8	19	0.6%
9	27	0.9%
10	27	0.9%

Value	Count	Frequency (%)
7837	1	< 0.1%
5586	1	< 0.1%
5095	1	< 0.1%
4577	1	< 0.1%
2697	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1672	1	< 0.1%
1636	1	< 0.1%

avg_ticket
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	2964
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	51.93158379

Minimum	2.150588235
Maximum	56157.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	2.150588235
5-th percentile	4.914341758
Q1	13.11982258
median	17.94687607
Q3	24.98612169
95-th percentile	90.50125
Maximum	56157.5
Range	56155.34941
Interquartile range (IQR)	11.86629911

Descriptive statistics

Standard deviation	1037.458318
Coefficient of variation (CV)	19.9774057
Kurtosis	2887.787214
Mean	51.93158379
Median Absolute Deviation (MAD)	5.975052174
Skewness	53.41722918
Sum	154029.0775
Variance	1076319.761
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14.47833333	2	0.1%
4.162	2	0.1%
18.15222222	1	< 0.1%
12.949	1	< 0.1%
16.29372093	1	< 0.1%
36.24411765	1	< 0.1%
29.78416667	1	< 0.1%
22.8792623	1	< 0.1%
20.51104167	1	< 0.1%
149.025	1	< 0.1%
Other values (2954)	2954	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%
2.707598253	1	< 0.1%
2.760621572	1	< 0.1%
2.770464191	1	< 0.1%

Value	Count	Frequency (%)
56157.5	1	< 0.1%
4453.43	1	< 0.1%
3202.92	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
872.13	1	< 0.1%
841.0214493	1	< 0.1%
651.1683333	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%

avg_recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	1258
Distinct (%)	42.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	67.38185752

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	8
Q1	26
median	48.39285714
Q3	85.33333333
95-th percentile	201
Maximum	366
Range	365
Interquartile range (IQR)	59.33333333

Descriptive statistics

Standard deviation	63.55905304
Coefficient of variation (CV)	0.9432665613
Kurtosis	4.883245776
Mean	67.38185752
Median Absolute Deviation (MAD)	26.27380952
Skewness	2.062428243
Sum	199854.5894
Variance	4039.753224
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14	25	0.8%
70	21	0.7%
4	21	0.7%
7	20	0.7%
35	18	0.6%
49	18	0.6%
46	17	0.6%
11	17	0.6%
21	17	0.6%
5	16	0.5%
Other values (1248)	2776	93.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	16	0.5%
1.5	1	< 0.1%
2	13	0.4%
2.5	1	< 0.1%
2.601398601	1	< 0.1%
3	15	0.5%
3.321428571	1	< 0.1%
3.330357143	1	< 0.1%
3.5	2	0.1%
4	21	0.7%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
363	1	< 0.1%
362	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	1223
Distinct (%)	41.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1134147061

Minimum	0.005449591281
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0.005449591281
5-th percentile	0.008892185955
Q1	0.01633986928
median	0.0258760183
Q3	0.04926691295
95-th percentile	1
Maximum	17
Range	16.99455041
Interquartile range (IQR)	0.03292704367

Descriptive statistics

Standard deviation	0.4080017981
Coefficient of variation (CV)	3.597432926
Kurtosis	991.9622892
Mean	0.1134147061
Median Absolute Deviation (MAD)	0.01217738816
Skewness	24.93321178
Sum	336.3880183
Variance	0.1664654673
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	197	6.6%
0.0625	17	0.6%
0.02777777778	17	0.6%
0.02380952381	16	0.5%
0.09090909091	15	0.5%
0.08333333333	15	0.5%
0.03448275862	14	0.5%
0.02941176471	14	0.5%
0.07692307692	13	0.4%
0.02564102564	13	0.4%
Other values (1213)	2635	88.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
3	1	< 0.1%
2	6	0.2%
1.142857143	1	< 0.1%
1	197	6.6%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5308310992	1	< 0.1%
0.5	3	0.1%

qtde_returns
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	214
Distinct (%)	7.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	62.12373567

Minimum	0
Maximum	80995
Zeros	1480
Zeros (%)	49.9%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	9
95-th percentile	100
Maximum	80995
Range	80995
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	1513.254167
Coefficient of variation (CV)	24.35871171
Kurtosis	2762.791257
Mean	62.12373567
Median Absolute Deviation (MAD)	1
Skewness	51.77236982
Sum	184259
Variance	2289938.175
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1480	49.9%
1	164	5.5%
2	147	5.0%
3	105	3.5%
4	89	3.0%
6	78	2.6%
5	61	2.1%
12	51	1.7%
7	43	1.4%
8	43	1.4%
Other values (204)	705	23.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1480	49.9%
1	164	5.5%
2	147	5.0%
3	105	3.5%
4	89	3.0%
5	61	2.1%
6	78	2.6%
7	43	1.4%
8	43	1.4%
9	41	1.4%

Value	Count	Frequency (%)
80995	1	< 0.1%
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3331	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%

avg_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	1974
Distinct (%)	66.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	249.6203673

Minimum	1
Maximum	40498.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	44.05555556
Q1	103.3083333
median	172.125
Q3	281.6442308
95-th percentile	599.7
Maximum	40498.5
Range	40497.5
Interquartile range (IQR)	178.3358974

Descriptive statistics

Standard deviation	791.9269277
Coefficient of variation (CV)	3.172525288
Kurtosis	2253.629865
Mean	249.6203673
Median Absolute Deviation (MAD)	82.875
Skewness	44.65585181
Sum	740374.0094
Variance	627148.2588
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
114	10	0.3%
86	9	0.3%
73	9	0.3%
82	9	0.3%
75	8	0.3%
140	8	0.3%
60	8	0.3%
136	8	0.3%
88	8	0.3%
Other values (1964)	2878	97.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
40498.5	1	< 0.1%
6009.333333	1	< 0.1%
4282	1	< 0.1%
3906	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2801	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%

avg_unique_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	1974
Distinct (%)	66.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	249.6203673

Minimum	1
Maximum	40498.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	23.3 KiB

Quantile statistics

Minimum	1
5-th percentile	44.05555556
Q1	103.3083333
median	172.125
Q3	281.6442308
95-th percentile	599.7
Maximum	40498.5
Range	40497.5
Interquartile range (IQR)	178.3358974

Descriptive statistics

Standard deviation	791.9269277
Coefficient of variation (CV)	3.172525288
Kurtosis	2253.629865
Mean	249.6203673
Median Absolute Deviation (MAD)	82.875
Skewness	44.65585181
Sum	740374.0094
Variance	627148.2588
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
114	10	0.3%
86	9	0.3%
73	9	0.3%
82	9	0.3%
75	8	0.3%
140	8	0.3%
60	8	0.3%
136	8	0.3%
88	8	0.3%
Other values (1964)	2878	97.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
40498.5	1	< 0.1%
6009.333333	1	< 0.1%
4282	1	< 0.1%
3906	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2801	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	customer_id	gross_revenue	recency_days	qtde_invoices	qtde_items	qtde_products	avg_ticket	avg_recency_days	frequency	qtde_returns	avg_basket_size	avg_unique_basket_size
0	0	17850	5391.2100	372.0000	34.0000	1733.0000	297.0000	18.1522	35.5000	17.0000	40.0000	50.9706	50.9706
1	1	13047	3232.5900	56.0000	9.0000	1390.0000	171.0000	18.9040	27.2500	0.0283	35.0000	154.4444	154.4444
2	2	12583	6705.3800	2.0000	15.0000	5028.0000	232.0000	28.9025	23.1875	0.0403	50.0000	335.2000	335.2000
3	3	13748	948.2500	95.0000	5.0000	439.0000	28.0000	33.8661	92.6667	0.0179	0.0000	87.8000	87.8000
4	4	15100	876.0000	333.0000	3.0000	80.0000	3.0000	292.0000	8.6000	0.0732	22.0000	26.6667	26.6667
5	5	15291	4623.3000	25.0000	14.0000	2102.0000	102.0000	45.3265	23.2000	0.0401	29.0000	150.1429	150.1429
6	6	14688	5630.8700	7.0000	21.0000	3621.0000	327.0000	17.2198	18.3000	0.0572	399.0000	172.4286	172.4286
7	7	17809	5411.9100	16.0000	12.0000	2057.0000	61.0000	88.7198	35.7000	0.0335	41.0000	171.4167	171.4167
8	8	15311	60767.9000	0.0000	91.0000	38194.0000	2379.0000	25.5435	4.1444	0.2433	474.0000	419.7143	419.7143
9	9	16098	2005.6300	87.0000	7.0000	613.0000	67.0000	29.9348	47.6667	0.0244	0.0000	87.5714	87.5714

Last rows

	df_index	customer_id	gross_revenue	recency_days	qtde_invoices	qtde_items	qtde_products	avg_ticket	avg_recency_days	frequency	qtde_returns	avg_basket_size	avg_unique_basket_size
2956	5602	17727	1060.2500	15.0000	1.0000	645.0000	66.0000	16.0644	6.0000	1.0000	6.0000	645.0000	645.0000
2957	5612	17232	421.5200	2.0000	2.0000	203.0000	36.0000	11.7089	12.0000	0.1538	0.0000	101.5000	101.5000
2958	5613	17468	137.0000	10.0000	2.0000	116.0000	5.0000	27.4000	4.0000	0.4000	0.0000	58.0000	58.0000
2959	5624	13596	697.0400	5.0000	2.0000	406.0000	166.0000	4.1990	7.0000	0.2500	0.0000	203.0000	203.0000
2960	5630	14893	1237.8500	9.0000	2.0000	799.0000	73.0000	16.9568	2.0000	0.6667	0.0000	399.5000	399.5000
2961	5634	12479	473.2000	11.0000	1.0000	382.0000	30.0000	15.7733	4.0000	1.0000	34.0000	382.0000	382.0000
2962	5655	14126	706.1300	7.0000	3.0000	508.0000	15.0000	47.0753	3.0000	0.7500	50.0000	169.3333	169.3333
2963	5661	13521	1092.3900	1.0000	3.0000	733.0000	435.0000	2.5112	4.5000	0.3000	0.0000	244.3333	244.3333
2964	5671	15060	301.8400	8.0000	4.0000	262.0000	120.0000	2.5153	1.0000	2.0000	0.0000	65.5000	65.5000
2965	5690	12558	269.9600	7.0000	1.0000	196.0000	11.0000	24.5418	6.0000	1.0000	196.0000	196.0000	196.0000

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows